Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'SUBTYP_1'.
|
|
The error occurred in C:/home/a1gunsngear.com/wwwroot/vendcategory.cfm: line 273
Called from C:/home/a1gunsngear.com/wwwroot/vendcategory.cfm: line 263
Called from C:/home/a1gunsngear.com/wwwroot/vendcategory.cfm: line 247
Called from C:/home/a1gunsngear.com/wwwroot/vendcategory.cfm: line 1
Called from C:/home/a1gunsngear.com/wwwroot/router.cfm: line 12
Called from C:/home/a1gunsngear.com/wwwroot/vendcategory.cfm: line 273
Called from C:/home/a1gunsngear.com/wwwroot/vendcategory.cfm: line 263
Called from C:/home/a1gunsngear.com/wwwroot/vendcategory.cfm: line 247
Called from C:/home/a1gunsngear.com/wwwroot/vendcategory.cfm: line 1
Called from C:/home/a1gunsngear.com/wwwroot/router.cfm: line 12
|
271 : <cfif Taxonomy.LEVEL EQ 3 and Taxonomy.SUBTYP_1 NEQ ''>
272 : and SUBTYP_1 = '#Taxonomy.SUBTYP_1#'
273 : <cfelse>
274 : and SUBTYP_1 <> 'EMPTY'
275 : </cfif>
|
|
SQLSTATE |
42S22 |
DATASOURCE |
a1gunsicumulus |
VENDORERRORCODE |
207 |
SQL |
SELECT distinct [DEPT] ,typ ,subtyp as SUBTYP_1 ,web_url FROM tb_ecomm_taxonomy
where DEPT = 'ACCESSORIES' and typ = 'Empty'
and SUBTYP_1 <> 'EMPTY'
and SUBTYP_2 IS NULL and web_url > ''
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.117.184.189 |
Referrer |
http://www.a1gunsngear.com/products/accessories/?cfilters=|Finish_Color~Flat%20Dark%20Earth |
Date/Time |
16-May-24 02:08 PM |
|